Re: SELECT clause no relation found.
От | John Pfersich |
---|---|
Тема | Re: SELECT clause no relation found. |
Дата | |
Msg-id | v04003a00bade161fa9fb@[12.83.80.221] обсуждение исходный текст |
Ответ на | Re: SELECT clause no relation found. (Barry Lind <blind@xythos.com>) |
Список | pgsql-jdbc |
It could also be that the table was created as "person" (with the quotes) instead of minus the quotes. SQL is suposed to be a caseless language, but if you force a case structure on it, it will conform to it quite rigidly. If you use case to define an object, you will be forced to continue to specify the case. >Mika, > >If you turn sql statement tracing on on the server, you could then see >the exact sql statements that are being sent from the jdbc driver to the >server. > >thanks, >--Barry > >Mika Pesu wrote: >> what's wrong with key sql >> >> select * from person; >> >> gives me error no person relation found >> >> but when i use >> select * from "person" >> >> doesn't give any error. >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 3: if posting/reading through Usenet, please send an appropriate >> subscribe-nomail command to majordomo@postgresql.org so that your >> message can get through to the mailing list cleanly >> > > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
В списке pgsql-jdbc по дате отправления: